Tabela BudgetCycleValueStage

Definicja tabeli BudgetCycleValueStage

Name

BudgetCycleValueStage

Code

BudgetCycleValueStage

Comment

Stage - funkcje, parametry i wartosci


Lista kolumn tabeli BudgetCycleValueStage

Name

Code

BudgetCycleValueStageID

BudgetCycleValueStageID

BudgetCycleID

BudgetCycleID

FunctionDefinitionID

FunctionDefinitionID

ResponsibilityCenterID

ResponsibilityCenterID

TimeAxisID

TimeAxisID

JGPGroupCode

JGPGroupCode

ServiceCode

ServiceCode

PriceListCode

PriceListCode

PeriodID

PeriodID

BudgetStructureElementID

BudgetStructureElementID

BudgetVariableID

BudgetVariableID

Account

Account

Posted

Posted

BSHierarchyLevel

BSHierarchyLevel

RCSHierarchyLevel

RCSHierarchyLevel

OPKCode

OPKCode

OuterOPKCode

OuterOPKCode

Value

Value

Period2ID

Period2ID


Kolumna BudgetCycleValueStageID tabeli BudgetCycleValueStage

Definicja kolumny BudgetCycleValueStageID tabeli BudgetCycleValueStage

Name

BudgetCycleValueStageID

Code

BudgetCycleValueStageID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID pozycji w stage


Kolumna BudgetCycleID tabeli BudgetCycleValueStage

Definicja kolumny BudgetCycleID tabeli BudgetCycleValueStage

Name

BudgetCycleID

Code

BudgetCycleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID cyklu budzetowego


Kolumna FunctionDefinitionID tabeli BudgetCycleValueStage

Definicja kolumny FunctionDefinitionID tabeli BudgetCycleValueStage

Name

FunctionDefinitionID

Code

FunctionDefinitionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID funkcji


Kolumna ResponsibilityCenterID tabeli BudgetCycleValueStage

Definicja kolumny ResponsibilityCenterID tabeli BudgetCycleValueStage

Name

ResponsibilityCenterID

Code

ResponsibilityCenterID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID osrodka odpowiedzialnosci


Kolumna TimeAxisID tabeli BudgetCycleValueStage

Definicja kolumny TimeAxisID tabeli BudgetCycleValueStage

Name

TimeAxisID

Code

TimeAxisID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID okresu dla którego wykonywane sa obliczenia


Kolumna JGPGroupCode tabeli BudgetCycleValueStage

Definicja kolumny JGPGroupCode tabeli BudgetCycleValueStage

Name

JGPGroupCode

Code

JGPGroupCode

Data Type

VARCHAR2(30)

Mandatory

No

Comment

Kod grupy JGP


Kolumna ServiceCode tabeli BudgetCycleValueStage

Definicja kolumny ServiceCode tabeli BudgetCycleValueStage

Name

ServiceCode

Code

ServiceCode

Data Type

VARCHAR2(30)

Mandatory

No

Comment

Kod procedury ICD9


Kolumna PriceListCode tabeli BudgetCycleValueStage

Definicja kolumny PriceListCode tabeli BudgetCycleValueStage

Name

PriceListCode

Code

PriceListCode

Data Type

VARCHAR2(30)

Mandatory

No

Comment

Kod cennika


Kolumna PeriodID tabeli BudgetCycleValueStage

Definicja kolumny PeriodID tabeli BudgetCycleValueStage

Name

PeriodID

Code

PeriodID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID okresu z którego nalezy pobrac dane


Kolumna BudgetStructureElementID tabeli BudgetCycleValueStage

Definicja kolumny BudgetStructureElementID tabeli BudgetCycleValueStage

Name

BudgetStructureElementID

Code

BudgetStructureElementID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID elementu struktury budzetu


Kolumna BudgetVariableID tabeli BudgetCycleValueStage

Definicja kolumny BudgetVariableID tabeli BudgetCycleValueStage

Name

BudgetVariableID

Code

BudgetVariableID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zmiennej


Kolumna Account tabeli BudgetCycleValueStage

Definicja kolumny Account tabeli BudgetCycleValueStage

Name

Account

Code

Account

Data Type

VARCHAR2(30)

Mandatory

No

Comment

Konto lub maska


Kolumna Posted tabeli BudgetCycleValueStage

Definicja kolumny Posted tabeli BudgetCycleValueStage

Name

Posted

Code

Posted

Data Type

VARCHAR2(3)

Mandatory

No

Comment

Flaga czy zaksiegowane


Kolumna BSHierarchyLevel tabeli BudgetCycleValueStage

Definicja kolumny BSHierarchyLevel tabeli BudgetCycleValueStage

Name

BSHierarchyLevel

Code

BSHierarchyLevel

Data Type

NUMBER(10)

Mandatory

No

Comment

Poziom w hierarchii struktury budzetu


Kolumna RCSHierarchyLevel tabeli BudgetCycleValueStage

Definicja kolumny RCSHierarchyLevel tabeli BudgetCycleValueStage

Name

RCSHierarchyLevel

Code

RCSHierarchyLevel

Data Type

NUMBER(10)

Mandatory

No

Comment

Poziom w hierarchii struktury osrodków odpowiedzialnosci


Kolumna OPKCode tabeli BudgetCycleValueStage

Definicja kolumny OPKCode tabeli BudgetCycleValueStage

Name

OPKCode

Code

OPKCode

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Kod osrodka powstawania kosztów


Kolumna OuterOPKCode tabeli BudgetCycleValueStage

Definicja kolumny OuterOPKCode tabeli BudgetCycleValueStage

Name

OuterOPKCode

Code

OuterOPKCode

Data Type

VARCHAR2(20)

Mandatory

No

Comment

Kod zewnetrznego osrodka powstawania kosztów


Kolumna Value tabeli BudgetCycleValueStage

Definicja kolumny Value tabeli BudgetCycleValueStage

Name

Value

Code

Value

Data Type

NUMBER(19,4)

Mandatory

No

Comment

Wartosc


Kolumna Period2ID tabeli BudgetCycleValueStage

Definicja kolumny Period2ID tabeli BudgetCycleValueStage

Name

Period2ID

Code

Period2ID

Data Type

NUMBER(12)

Mandatory

No

Comment

ID konca okresu z którego nalezy pobrac dane


Lista kluczy tabeli BudgetCycleValueStage

Name

Code

Primary

PK_BUDGETCYCLEVALUESTAGE

PK_BUDGETCYCLEVALUESTAGE

X


Klucz PK_BUDGETCYCLEVALUESTAGE tabeli BudgetCycleValueStage

Definicja klucza PK_BUDGETCYCLEVALUESTAGE tabeli BudgetCycleValueStage

Name

PK_BUDGETCYCLEVALUESTAGE

Code

PK_BUDGETCYCLEVALUESTAGE

Primary

Yes

Comment